$gris ="#c4c4c4";
$meta_description = "Bienvenue sur TSM";
$meta_keywords = "TSM, Spa, Audit";
$title = "";
include ("php/chemin.php");
include ("php/connexion.php");
include ("php/validlink.php");
include ("php/trad.php");
$id_menu = $_GET['id_menu'] ;
$id_sousmenu = $_GET['id_sousmenu'] ;
$alias_langues = $_GET['alias_langues'] ;
$sql_langues = "SELECT * FROM tab_langues WHERE alias='".$alias_langues."'";
$req_langues = mysqli_query($db, $sql_langues) or die('Erreur SQL !
'.$sql_langues.'
'.mysqli_error($db));
$result_langues = mysqli_fetch_assoc($req_langues);
$id_langues = $result_langues ['id'];
?>
$req_menu = "SELECT * FROM tab_menu WHERE visible='1' ORDER BY ordre";
$exec_menu = mysqli_query($db, $req_menu);
$menu = "";
while($result_menu = mysqli_fetch_assoc($exec_menu))
{
if($id_menu == 0)
{
$id_menu = $result_menu['id'];
}
$req_menu_l = "SELECT * FROM tab_menu_l WHERE id_menu = '" . $result_menu['id'] . "' AND id_langues = '" .$id_langues. "'";
$exec_menu_l = mysqli_query($db, $req_menu_l);
$result_menu_l = mysqli_fetch_assoc($exec_menu_l);
if($result_menu['id']==$id_menu)
{
$fontweight = "bold";
$couleurFond = "#474747";
$couleurPolice = $result_menu['couleurClaire'];
$couleurFoncee = $result_menu['couleurFoncee'];
$couleurClaire= $result_menu['couleurClaire'];
$premiersousmenu = $result_menu['id_sousmenu'];
$titre_menu = $result_menu_l['nom_ref'];
$imageGauche = $result_menu['file_imageGauche_images'];
$soustitre = $result_menu_l['soustitre'];
$template = $result_menu['template'];
if ($titre_menu == "TSM")
{
$titre_menu = "THALGO SPA MANAGEMENT";
}
$meta_description = $result_menu_l['meta_description'];
$meta_keywords = $result_menu_l['meta_keywords'];
$title = $result_menu_l['titre'];
if($result_menu['id_structure'] == 1)
{
$largeur = 950;
$hauteur = 258;
$swf = "animation1.swf";
}
else if ($result_menu['id_structure'] == 2)
{
$largeur = 672;
$hauteur = 450;
$swf = "animation2.swf";
}
$left = 950 - $largeur;
}
else
{
$fontweight = "normal";
$couleurFond = "#363636";
$couleurPolice = "#ffffff";
}
$menu .= "".$result_menu_l['nom_ref']."";
}
if($id_sousmenu == 0)
{
$id_sousmenu = $premiersousmenu;
}
$req_sousmenu = "SELECT * FROM tab_sousmenu WHERE id_menu = '" .$id_menu."' AND visible='1' ORDER BY ordre";
$exec_sousmenu = mysqli_query($db, $req_sousmenu);
$num_sousmenu = mysqli_num_rows($exec_sousmenu);
$sousmenu = "";
while($result_sousmenu = mysqli_fetch_assoc($exec_sousmenu))
{
$req_sousmenu_l = "SELECT * FROM tab_sousmenu_l WHERE id_sousmenu = '" . $result_sousmenu['id'] . "' AND id_langues = '" .$id_langues. "'";
$exec_sousmenu_l = mysqli_query($db, $req_sousmenu_l);
$result_sousmenu_l = mysqli_fetch_assoc($exec_sousmenu_l);
if($result_sousmenu['id']==$id_sousmenu)
{
$fontweight = "bold";
$couleurFond = "#474747";
$couleurPolice = $couleurClaire;
$meta_description = $result_sousmenu_l['meta_description'];
$meta_keywords = $result_sousmenu_l['meta_keywords'];
$title = $result_sousmenu_l['titre'];
$template = $result_sousmenu['template'];
}
else
{
$fontweight = "normal";
$couleurFond = "#252525";
$couleurPolice = $gris;
}
$sousmenu .= "".$result_sousmenu_l['nom_ref']." ";
//echo "
";
}
if ($num_sousmenu==0)
{
$sousmenu .= "
if($template=="references")
{
echo "
";
if ($_GET['page']==0)
{
echo "
";
}
else
{
echo "
";
}
echo "
";
}
?>
";
}
$sql_lienDiagnostic ="SELECT * FROM tab_menu WHERE visible='1' AND template='diagnostic'";
$req_lienDiagnostic = mysqli_query($db, $sql_lienDiagnostic) or die('Erreur SQL !
'.$sql_lienDiagnostic .'
'.mysqli_error($db));
$result_lienDiagnostic = mysqli_fetch_assoc($req_lienDiagnostic);
$num_lienDiagnostic = mysqli_num_rows($req_lienDiagnostic);
if($num_lienDiagnostic>0)
{
echo "
";
}
}
?>
if($imageGauche != "")
{
echo "
";
}
?>
include ("php/".$template.".php");?>
echo "
";
echo "
";
$sql = "SELECT * FROM tab_pdf WHERE visible='1'";
if($id_sousmenu !=0)
{
$sql .= "AND id_sousmenu='".$id_sousmenu."'";
}
else
{
$sql .= "AND id_menu='".$id_menu."'";
}
$sql .= "ORDER BY ordre";
$req = mysqli_query($db, $sql) or die('Erreur SQL !
'.$sql_textes .'
'.mysqli_error($db));
while ($result = mysqli_fetch_assoc($req))
{
$sql_l = "SELECT * FROM tab_pdf_l WHERE id_pdf='".$result['id']."' AND id_langues='".$id_langues."'";
$req_l = mysqli_query($db, $sql_l) or die('Erreur SQL !
'.$sql_l .'
'.mysqli_error($db));
$result_l = mysqli_fetch_assoc($req_l);
echo "
";
}
?>